Dataset info
| Number of variables | 8 |
|---|---|
| Number of observations | 99072 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 6.0 MiB |
| Average record size in memory | 64.0 B |
Variables types
| Numeric | 5 |
|---|---|
| Categorical | 1 |
| Boolean | 0 |
| Date | 1 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 1 |
| Unsupported | 0 |
city
Categorical
| Distinct count | 61 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Bangalore | |
|---|---|
| Channapatna | 1815 |
| Ramanagaram | 1318 |
| Other values (58) |
| Value | Count | Frequency (%) | |
| Bangalore | 49939 | 50.4% | |
| Channapatna | 1815 | 1.8% | |
| Ramanagaram | 1318 | 1.3% | |
| Chitradurga | 1308 | 1.3% | |
| Tumkur | 1244 | 1.3% | |
| Karwar | 1198 | 1.2% | |
| Bijapur | 1164 | 1.2% | |
| Challakere | 1104 | 1.1% | |
| Kollegal | 1104 | 1.1% | |
| Udupi | 1096 | 1.1% | |
| Other values (51) | 37782 | 38.1% |
| Max length | 15 |
|---|---|
| Mean length | 8.472999435 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
device_id
Numeric
| Distinct count | 6481 |
|---|---|
| Unique (%) | 6.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.588320934e+15 |
|---|---|
| Minimum | -9.22106649e+18 |
| Maximum | 9.21497389e+18 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -9.22106649e+18 |
|---|---|
| 5-th percentile | -8.587004742e+18 |
| Q1 | -4.60687483e+18 |
| Median | -2.06674354e+16 |
| Q3 | 4.840783435e+18 |
| 95-th percentile | 8.396440232e+18 |
| Maximum | 9.21497389e+18 |
| Range | 1.843604038e+19 |
| Interquartile range | 9.447658264e+18 |
Descriptive statistics
| Standard deviation | 5.393253255e+18 |
|---|---|
| Coef of variation | 965.0936871 |
| Kurtosis | -1.217173548 |
| Mean | 5.588320934e+15 |
| MAD | 4.679140497e+18 |
| Skewness | -0.02980802377 |
| Sum | 5.536461316e+20 |
| Variance | 2.908718067e+37 |
| Memory size | 774.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-9.22106649e+18 -9.22094867e+18 -9.22005014e+18 -9.21894088e+18 -9.21480889e+18 ... 9.20012831e+18 9.20214188e+18 9.20517454e+18 9.20631418e+18 9.21497389e+18], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -8.610583201e+18 | 906 | 0.9% | |
| 6.218978703e+18 | 370 | 0.4% | |
| 3.723410909e+18 | 369 | 0.4% | |
| -6.903863102e+18 | 320 | 0.3% | |
| -3.33391831e+18 | 307 | 0.3% | |
| 4.143944772e+18 | 278 | 0.3% | |
| 7.392201673e+18 | 271 | 0.3% | |
| -7.109735224e+18 | 259 | 0.3% | |
| -5.272268728e+17 | 256 | 0.3% | |
| 6.423644613e+18 | 236 | 0.2% | |
| Other values (6471) | 95500 | 96.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -9.22106649e+18 | 22 | < 0.1% | |
| -9.220830859e+18 | 8 | < 0.1% | |
| -9.21926942e+18 | 97 | 0.1% | |
| -9.218612338e+18 | 6 | < 0.1% | |
| -9.217193238e+18 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9.21497389e+18 | 22 | < 0.1% | |
| 9.208160883e+18 | 16 | < 0.1% | |
| 9.207308633e+18 | 13 | < 0.1% | |
| 9.205319726e+18 | 33 | < 0.1% | |
| 9.205029352e+18 | 11 | < 0.1% |
df_index
Numeric
| Distinct count | 99072 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3050054.488 |
|---|---|
| Minimum | 2951416 |
| Maximum | 3252945 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2951416 |
|---|---|
| 5-th percentile | 2956369.55 |
| Q1 | 2976183.75 |
| Median | 3000951.5 |
| Q3 | 3117500.25 |
| 95-th percentile | 3225424.45 |
| Maximum | 3252945 |
| Range | 301529 |
| Interquartile range | 141316.5 |
Descriptive statistics
| Standard deviation | 90047.51749 |
|---|---|
| Coef of variation | 0.0295232488 |
| Kurtosis | -0.7809861277 |
| Mean | 3050054.488 |
| MAD | 78221.16244 |
| Skewness | 0.7681568081 |
| Sum | 3.021749982e+11 |
| Variance | 8108555405 |
| Memory size | 774.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[2951416. 3000959.5 3001213.5 3001231.5 3001309.5 ... 3248734.5 3248978.5 3248988.5 3249242.5 3252945. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3113714 | 1 | < 0.1% | |
| 3119499 | 1 | < 0.1% | |
| 2968188 | 1 | < 0.1% | |
| 2966141 | 1 | < 0.1% | |
| 2972286 | 1 | < 0.1% | |
| 2970239 | 1 | < 0.1% | |
| 3215182 | 1 | < 0.1% | |
| 3056257 | 1 | < 0.1% | |
| 3193474 | 1 | < 0.1% | |
| 3121510 | 1 | < 0.1% | |
| Other values (99062) | 99062 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2951416 | 1 | < 0.1% | |
| 2951417 | 1 | < 0.1% | |
| 2951418 | 1 | < 0.1% | |
| 2951419 | 1 | < 0.1% | |
| 2951420 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3252945 | 1 | < 0.1% | |
| 3252937 | 1 | < 0.1% | |
| 3252934 | 1 | < 0.1% | |
| 3252910 | 1 | < 0.1% | |
| 3252901 | 1 | < 0.1% |
event_id
Numeric
| Distinct count | 99072 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1648706.211 |
|---|---|
| Minimum | 20902 |
| Maximum | 3252946 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20902 |
|---|---|
| 5-th percentile | 259263.45 |
| Q1 | 834466.75 |
| Median | 1641787.5 |
| Q3 | 2448305 |
| 95-th percentile | 3092085.35 |
| Maximum | 3252946 |
| Range | 3232044 |
| Interquartile range | 1613838.25 |
Descriptive statistics
| Standard deviation | 919263.741 |
|---|---|
| Coef of variation | 0.5575667363 |
| Kurtosis | -1.215030851 |
| Mean | 1648706.211 |
| MAD | 797234.4681 |
| Skewness | 0.02756812681 |
| Sum | 1.633406217e+11 |
| Variance | 8.450458255e+11 |
| Memory size | 774.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 20902. 201979.5 625613. 3252946. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1128414 | 1 | < 0.1% | |
| 1658856 | 1 | < 0.1% | |
| 698389 | 1 | < 0.1% | |
| 1396781 | 1 | < 0.1% | |
| 720604 | 1 | < 0.1% | |
| 960537 | 1 | < 0.1% | |
| 2269288 | 1 | < 0.1% | |
| 2530010 | 1 | < 0.1% | |
| 2793596 | 1 | < 0.1% | |
| 207368 | 1 | < 0.1% | |
| Other values (99062) | 99062 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20902 | 1 | < 0.1% | |
| 21030 | 1 | < 0.1% | |
| 21088 | 1 | < 0.1% | |
| 21136 | 1 | < 0.1% | |
| 21318 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3252946 | 1 | < 0.1% | |
| 3252937 | 1 | < 0.1% | |
| 3252881 | 1 | < 0.1% | |
| 3252880 | 1 | < 0.1% | |
| 3252855 | 1 | < 0.1% |
latitude
Numeric
| Distinct count | 6369 |
|---|---|
| Unique (%) | 6.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.73707947 |
|---|---|
| Minimum | 11.931887 |
| Maximum | 25.2048 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 11.931887 |
|---|---|
| 5-th percentile | 12.715878 |
| Q1 | 13.005586 |
| Median | 13.048646 |
| Q3 | 14.0284 |
| 95-th percentile | 16.80095 |
| Maximum | 25.2048 |
| Range | 13.272913 |
| Interquartile range | 1.022814 |
Descriptive statistics
| Standard deviation | 1.347772017 |
|---|---|
| Coef of variation | 0.0981119764 |
| Kurtosis | 1.462449473 |
| Mean | 13.73707947 |
| MAD | 1.054927397 |
| Skewness | 1.591455731 |
| Sum | 1360959.937 |
| Variance | 1.816489409 |
| Memory size | 774.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[11.931887 11.932398 11.9324525 11.990741 11.9913375 ... 17.9970095 18.001354 18.0133945 18.0180895 25.2048 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 12.715878 | 906 | 0.9% | |
| 12.82238 | 370 | 0.4% | |
| 12.737445 | 369 | 0.4% | |
| 15.984554 | 317 | 0.3% | |
| 14.00437 | 307 | 0.3% | |
| 13.476138 | 278 | 0.3% | |
| 16.228846 | 271 | 0.3% | |
| 13.321003 | 259 | 0.3% | |
| 17.944439 | 256 | 0.3% | |
| 12.738951 | 236 | 0.2% | |
| Other values (6359) | 95503 | 96.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 11.931887 | 3 | < 0.1% | |
| 11.932395 | 6 | < 0.1% | |
| 11.932401 | 21 | < 0.1% | |
| 11.932504 | 11 | < 0.1% | |
| 11.943384 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 25.2048 | 3 | < 0.1% | |
| 18.01851 | 9 | < 0.1% | |
| 18.017669 | 6 | < 0.1% | |
| 18.014072 | 20 | < 0.1% | |
| 18.012717 | 3 | < 0.1% |
longitude
Numeric
| Distinct count | 6353 |
|---|---|
| Unique (%) | 6.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 77.02816028 |
|---|---|
| Minimum | 74.130388 |
| Maximum | 78.371192 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 74.130388 |
|---|---|
| 5-th percentile | 74.881511 |
| Q1 | 76.686884 |
| Median | 77.58214 |
| Q3 | 77.626615 |
| 95-th percentile | 77.659622 |
| Maximum | 78.371192 |
| Range | 4.240804 |
| Interquartile range | 0.939731 |
Descriptive statistics
| Standard deviation | 0.9395412889 |
|---|---|
| Coef of variation | 0.01219737412 |
| Kurtosis | 0.8577524562 |
| Mean | 77.02816028 |
| MAD | 0.7483953842 |
| Skewness | -1.406883894 |
| Sum | 7631333.895 |
| Variance | 0.8827378335 |
| Memory size | 774.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[74.130388 74.132535 74.134836 74.1422135 74.147168 ... 78.3340845 78.350703 78.3631475 78.3683505 78.371192 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 77.209356 | 906 | 0.9% | |
| 74.906026 | 370 | 0.4% | |
| 77.207593 | 369 | 0.4% | |
| 76.224259 | 320 | 0.3% | |
| 76.671906 | 307 | 0.3% | |
| 77.936359 | 278 | 0.3% | |
| 74.881511 | 271 | 0.3% | |
| 76.492793 | 259 | 0.3% | |
| 76.961038 | 256 | 0.3% | |
| 77.338099 | 236 | 0.2% | |
| Other values (6343) | 95500 | 96.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 74.130388 | 35 | < 0.1% | |
| 74.134682 | 156 | 0.2% | |
| 74.13499 | 11 | < 0.1% | |
| 74.137444 | 29 | < 0.1% | |
| 74.13816 | 41 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 78.371192 | 33 | < 0.1% | |
| 78.365509 | 1 | < 0.1% | |
| 78.363502 | 1 | < 0.1% | |
| 78.362793 | 12 | < 0.1% | |
| 78.358757 | 65 | 0.1% |
state
Constant
This variable is constant and should be ignored for analysis
| Constant value | Karnataka |
|---|
timestamp
Date
| Distinct count | 89571 |
|---|---|
| Unique (%) | 90.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2016-04-30 23:52:24 |
|---|---|
| Maximum | 2016-05-07 23:59:06 |
Histogram of 'timestamp' (bins=N)
First rows
| city | device_id | df_index | event_id | latitude | longitude | state | timestamp | |
|---|---|---|---|---|---|---|---|---|
| 0 | Bangalore | -264,981,784,288,946,400.0 | 2951416 | 201,975.0 | 13.0 | 77.6 | Karnataka | 2016-05-07 12:09:27 |
| 1 | Bangalore | -264,981,784,288,946,400.0 | 2951417 | 746,412.0 | 13.0 | 77.6 | Karnataka | 2016-05-07 20:05:03 |
| 2 | Bangalore | -264,981,784,288,946,400.0 | 2951418 | 1,037,329.0 | 13.0 | 77.6 | Karnataka | 2016-05-01 12:20:38 |
| 3 | Bangalore | -264,981,784,288,946,400.0 | 2951419 | 1,826,194.0 | 13.0 | 77.6 | Karnataka | 2016-05-01 12:17:21 |
| 4 | Bangalore | -264,981,784,288,946,400.0 | 2951420 | 3,065,051.0 | 13.0 | 77.6 | Karnataka | 2016-05-06 12:06:14 |
| 5 | Bangalore | -264,981,784,288,946,400.0 | 2951421 | 3,119,547.0 | 13.0 | 77.6 | Karnataka | 2016-05-07 10:16:02 |
| 6 | Bangalore | 3,920,728,480,131,979,264.0 | 2951422 | 202,001.0 | 13.0 | 77.7 | Karnataka | 2016-05-07 12:38:58 |
| 7 | Bangalore | 3,920,728,480,131,979,264.0 | 2951423 | 221,539.0 | 13.0 | 77.7 | Karnataka | 2016-05-04 09:19:27 |
| 8 | Bangalore | 3,920,728,480,131,979,264.0 | 2951424 | 398,164.0 | 13.0 | 77.7 | Karnataka | 2016-05-04 22:23:52 |
| 9 | Bangalore | 3,920,728,480,131,979,264.0 | 2951425 | 591,462.0 | 13.0 | 77.7 | Karnataka | 2016-05-04 23:50:25 |
Last rows
| city | device_id | df_index | event_id | latitude | longitude | state | timestamp | |
|---|---|---|---|---|---|---|---|---|
| 99062 | Tumkur | 2,713,652,839,033,492,480.0 | 3252869 | 3,083,860.0 | 13.4 | 77.2 | Karnataka | 2016-05-01 00:37:23 |
| 99063 | Tiptur | -3,505,748,720,567,863,808.0 | 3252870 | 3,085,078.0 | 13.3 | 76.6 | Karnataka | 2016-05-04 08:18:55 |
| 99064 | Sira | -1,684,826,609,267,635,712.0 | 3252890 | 3,120,062.0 | 13.8 | 76.9 | Karnataka | 2016-05-03 11:25:45 |
| 99065 | Mandya | -785,046,573,419,645,056.0 | 3252892 | 3,132,433.0 | 12.6 | 76.9 | Karnataka | 2016-05-02 12:12:25 |
| 99066 | Tumkur | -1,403,242,147,935,198,976.0 | 3252900 | 3,151,964.0 | 13.4 | 77.2 | Karnataka | 2016-05-05 13:08:10 |
| 99067 | Tumkur | -1,403,242,147,935,198,976.0 | 3252901 | 3,154,327.0 | 13.4 | 77.2 | Karnataka | 2016-05-05 14:15:04 |
| 99068 | Krishnarajapura | 3,804,801,114,025,227,264.0 | 3252910 | 3,174,661.0 | 13.0 | 77.8 | Karnataka | 2016-05-02 17:21:25 |
| 99069 | Channapatna | 4,923,097,247,878,223,872.0 | 3252934 | 3,215,808.0 | 12.7 | 77.2 | Karnataka | 2016-05-03 23:53:01 |
| 99070 | Rabkavi | 8,033,389,325,581,660,160.0 | 3252937 | 3,230,874.0 | 16.5 | 75.2 | Karnataka | 2016-05-05 10:06:10 |
| 99071 | Chitradurga | 6,057,196,279,748,328,448.0 | 3252945 | 3,241,600.0 | 14.3 | 76.4 | Karnataka | 2016-05-04 17:51:29 |